﻿CREATE TABLE [account].[AccountMappingType] (
    [AccountMappingTypeId]      SMALLINT      IDENTITY (1, 1) NOT NULL,
    [AccountHierarchyId]        SMALLINT      NOT NULL,
    [AccountMappingTypeCode]    VARCHAR (30)  NOT NULL,
    [AccountMappingTypeName]    VARCHAR (200) NOT NULL,
    [ChildAccountCateryId]      SMALLINT      NOT NULL,
    [ChildAccountType]          CHAR (1)      NOT NULL,
    [ParentAccountCateryId]     SMALLINT      NOT NULL,
    [ParentAccountType]         CHAR (1)      NOT NULL,
    [IsAccountMappingMandatory] BIT           NOT NULL,
    [AccountMappingTypeOrderBy] SMALLINT      NOT NULL,
    PRIMARY KEY CLUSTERED ([AccountMappingTypeId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

